package com.jwsoft.manager.core.dao.mapper;

import com.jwsoft.manager.core.dao.model.EduSocialSecurityDetail;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jwsoft.manager.core.dao.model.EduhSocialSecurityDetail;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* <p>
  *  Mapper 接口
  * </p>
*
* @author chenzh
* @since 2023-03-21
*/
@Mapper
public interface EduSocialSecurityDetailMapper extends BaseMapper<EduSocialSecurityDetail> {

    Integer selectCountByYear(@Param("year") Integer year);

    List<EduSocialSecurityDetail> selectByYear(@Param("year") Integer year,@Param("pageSize") Integer pageSize);

    Integer deleteByTaskHistory(@Param("taskDetailId") String taskDetailId);

    Integer selectEncryptionCountByYear(@Param("year") Integer year, @Param("taskDetailId") String taskDetailId);

    List<EduhSocialSecurityDetail> selectEncryptionByYear(@Param("year") Integer year, @Param("taskDetailId") String taskDetailId, @Param("pageSize") Integer pageSize);

    List<EduhSocialSecurityDetail> queryCleanData(String taskDetailId, Integer year);
}
